Inventory Item Import Template

Configuration > Utilities > Data Import Templates

The Inventory Items Data Import Template is used to import item inventory information.

The following fields can be added to the Item Data Import Template:

Entity Model	Data Entity Mapping Type Required
Allergies	Allergy
Asset Account	Chart of Accounts
Base Unit of Measure Name
Description
Expense Account	Chart of Account
Identifier
Ignore
Is Discontinued
Is Inventoried Item Note:  Any text in field will mark item with attribute. A blank field will not mark item with attribute.
Is Purchased Item Note: Any text in field will mark item with attribute. A blank field will not mark item with attribute.
Item Category	Item Category
Item Tags
Manufacturer
Manufacturer Item Number
Name
Preferred Unit of Measure Name
Preferred Unit of Measure Quantity
Preferred Vendor	Vendor
Preferred Vendor Cost
Preferred Vendor Discount
Preferred Vendor Handling Fee
Preferred Vendor Identifier
Preferred Vendor is Local Food
Preferred Vendor is Taxable by Vendor
Preferred Vendor is USDA Food
Preferred Vendor USDA Value
Preferred Vendor Unit of Measure
Secondary Unit of Measure Name
Secondary Unit of Measure Quantity
Secondary Vendor	Vendor
Secondary Vendor Cost
Secondary Vendor Discount
Secondary Vendor Handling Fee
Secondary Vendor Identifier
Secondary Vendor is Local Food
Secondary Vendor is Taxable by Vendor
Secondary Vendor is USDA Food
Secondary Vendor USDA Value
Secondary Vendor Unit of Measure